Pandas Profiling Report

Dataset statistics

Number of variables	49
Number of observations	9224587
Missing cells	44304565
Missing cells (%)	9.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.4 GiB
Average record size in memory	400.0 B

Variable types

Numeric	15
Categorical	29
Boolean	5

Alerts

`ORIGIN_AIRPORT_CODE` has a high cardinality: 657 distinct values	High cardinality
`DESTINATION_AIRPORT_CODE` has a high cardinality: 679 distinct values	High cardinality
`FLIGHT_DATE_LOCAL` has a high cardinality: 727 distinct values	High cardinality
`TIME_DEPARTURE_LOCAL_TIME` has a high cardinality: 1051 distinct values	High cardinality
`AIRCRAFT_TYPE` has a high cardinality: 65 distinct values	High cardinality
`FARE_BASIS` has a high cardinality: 33211 distinct values	High cardinality
`UPGRADE_SALES_DATE` has a high cardinality: 481 distinct values	High cardinality
`FORM_OF_PAYMENT` has a high cardinality: 79 distinct values	High cardinality
`LOYAL_CUSTOMER_DATE_OF_BIRTH` has a high cardinality: 24920 distinct values	High cardinality
`LOYAL_CUSTOMER_REGISTERED_DATE` has a high cardinality: 8930 distinct values	High cardinality
`SALES_DATE` has a high cardinality: 365 distinct values	High cardinality
`INTINERARY` has a high cardinality: 55794 distinct values	High cardinality
`BOOKING_ORIGIN_AIRPORT` has a high cardinality: 145 distinct values	High cardinality
`BOOKING_ORIGIN_COUNTRY_CODE` has a high cardinality: 51 distinct values	High cardinality
`BOOKING_DEPARTURE_TIME_UTC` has a high cardinality: 83698 distinct values	High cardinality
`BOOKING_DESTINATION_AIRPORT` has a high cardinality: 147 distinct values	High cardinality
`BOOKING_ARRIVAL_TIME_UTC` has a high cardinality: 86418 distinct values	High cardinality
`MARKETING_CARRIER` is highly correlated with `OPERATIONAL_CARRIER`	High correlation
`OPERATIONAL_CARRIER` is highly correlated with `MARKETING_CARRIER`	High correlation
`STAY_LENGTH_D` is highly correlated with `SEGMENTS`	High correlation
`FLIGHT_COUPONS` is highly correlated with `PAX_N`	High correlation
`SEGMENTS` is highly correlated with `STAY_LENGTH_D`	High correlation
`PAX_N` is highly correlated with `FLIGHT_COUPONS`	High correlation
`MARKETING_CARRIER` is highly correlated with `OPERATIONAL_CARRIER`	High correlation
`OPERATIONAL_CARRIER` is highly correlated with `MARKETING_CARRIER`	High correlation
`STAY_LENGTH_D` is highly correlated with `SEGMENTS`	High correlation
`FLIGHT_COUPONS` is highly correlated with `PAX_N`	High correlation
`SEGMENTS` is highly correlated with `STAY_LENGTH_D`	High correlation
`PAX_N` is highly correlated with `FLIGHT_COUPONS`	High correlation
`MARKETING_CARRIER` is highly correlated with `OPERATIONAL_CARRIER`	High correlation
`OPERATIONAL_CARRIER` is highly correlated with `MARKETING_CARRIER`	High correlation
`STAY_LENGTH_D` is highly correlated with `SEGMENTS`	High correlation
`FLIGHT_COUPONS` is highly correlated with `PAX_N`	High correlation
`SEGMENTS` is highly correlated with `STAY_LENGTH_D`	High correlation
`PAX_N` is highly correlated with `FLIGHT_COUPONS`	High correlation
`UPGRADE_TYPE` is highly correlated with `BOOKING_DOMESTIC_FLAG` and 1 other fields	High correlation
`BOOKING_DOMESTIC_FLAG` is highly correlated with `UPGRADE_TYPE`	High correlation
`FLIGHT_RANGE` is highly correlated with `AIRCRAFT_TYPE` and 1 other fields	High correlation
`BOOKING_ORIGIN_COUNTRY_CODE` is highly correlated with `BOOKING_LONG_HOUL_FLAG`	High correlation
`AIRCRAFT_TYPE` is highly correlated with `FLIGHT_RANGE` and 1 other fields	High correlation
`BOOKED_CLASS` is highly correlated with `BOOKED_CABIN`	High correlation
`CURRENCY` is highly correlated with `BOOKING_LONG_HOUL_FLAG`	High correlation
`VAB` is highly correlated with `BOOKING_LONG_HOUL_FLAG`	High correlation
`BOOKING_LONG_HOUL_FLAG` is highly correlated with `FLIGHT_RANGE` and 5 other fields	High correlation
`UPGRADED_FLAG` is highly correlated with `UPGRADE_TYPE`	High correlation
`BOOKED_CABIN` is highly correlated with `BOOKED_CLASS`	High correlation
`BOOKING_DESTINATION_COUNTRY_CODE` is highly correlated with `BOOKING_LONG_HOUL_FLAG`	High correlation
`FLIGHT_DISTANCE` is highly correlated with `FLIGHT_RANGE` and 7 other fields	High correlation
`FLIGHT_RANGE` is highly correlated with `FLIGHT_DISTANCE` and 5 other fields	High correlation
`MARKETING_CARRIER` is highly correlated with `OPERATIONAL_CARRIER` and 1 other fields	High correlation
`OPERATIONAL_CARRIER` is highly correlated with `FLIGHT_DISTANCE` and 3 other fields	High correlation
`BOOKED_CLASS` is highly correlated with `BOOKED_CABIN` and 3 other fields	High correlation
`BOOKED_CABIN` is highly correlated with `BOOKED_CLASS` and 3 other fields	High correlation
`AIRCRAFT_TYPE` is highly correlated with `FLIGHT_DISTANCE` and 8 other fields	High correlation
`VAB` is highly correlated with `FLIGHT_DISTANCE` and 7 other fields	High correlation
`UPGRADE_TYPE` is highly correlated with `BOOKED_CABIN`	High correlation
`ORIGINAL_TICKET_NUMBER` is highly correlated with `FORM_OF_PAYMENT`	High correlation
`FORM_OF_PAYMENT` is highly correlated with `ORIGINAL_TICKET_NUMBER` and 4 other fields	High correlation
`CURRENCY` is highly correlated with `FLIGHT_DISTANCE` and 7 other fields	High correlation
`TOTAL_PRICE` is highly correlated with `CURRENCY`	High correlation
`TOTAL_PRICE_PLN` is highly correlated with `BOOKED_CABIN` and 1 other fields	High correlation
`PAX_TYPE` is highly correlated with `TOTAL_PRICE_PLN`	High correlation
`SALES_MARKET` is highly correlated with `FORM_OF_PAYMENT` and 4 other fields	High correlation
`SALES_CHANNEL` is highly correlated with `FORM_OF_PAYMENT`	High correlation
`TRIP_TYPE` is highly correlated with `SEGMENTS`	High correlation
`BOOKING_LONG_HOUL_FLAG` is highly correlated with `FLIGHT_DISTANCE` and 7 other fields	High correlation
`FLIGHT_COUPONS` is highly correlated with `BOOKED_CLASS` and 1 other fields	High correlation
`SEGMENTS` is highly correlated with `TRIP_TYPE`	High correlation
`PAX_N` is highly correlated with `BOOKED_CLASS` and 1 other fields	High correlation
`BOOKING_ORIGIN_COUNTRY_CODE` is highly correlated with `FLIGHT_DISTANCE` and 8 other fields	High correlation
`BOOKING_DESTINATION_COUNTRY_CODE` is highly correlated with `FLIGHT_DISTANCE` and 8 other fields	High correlation
`UPGRADE_TYPE` has 9215782 (99.9%) missing values	Missing
`UPGRADE_SALES_DATE` has 9215782 (99.9%) missing values	Missing
`LOYAL_CUSTOMER_ID` has 7840881 (85.0%) missing values	Missing
`LOYAL_CUSTOMER_DATE_OF_BIRTH` has 7848547 (85.1%) missing values	Missing
`LOYAL_CUSTOMER_REGISTERED_DATE` has 7840881 (85.0%) missing values	Missing
`BOOKING_DESTINATION_AIRPORT` has 1170692 (12.7%) missing values	Missing
`BOOKING_DESTINATION_COUNTRY_CODE` has 1170692 (12.7%) missing values	Missing
`ORIGINAL_TICKET_NUMBER` is highly skewed (γ1 = -50.30191515)	Skewed
`TOTAL_PRICE` is highly skewed (γ1 = 117.8490263)	Skewed
`BOOKING_WINDOW_D` has 166525 (1.8%) zeros	Zeros
`STAY_LENGTH_D` has 321065 (3.5%) zeros	Zeros

Reproduction

Analysis started	2022-03-19 13:39:40.709376
Analysis finished	2022-03-19 14:26:20.026961
Duration	46 minutes and 39.32 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

TICKET_NUMBER
Real number (ℝ_≥0)

Distinct	3944503
Distinct (%)	42.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.000223243 × 10¹⁵

Minimum	621301964
Maximum	9.999996297 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	621301964
5-th percentile	4.994320244 × 10¹⁴
Q1	2.498187979 × 10¹⁵
median	5.002537448 × 10¹⁵
Q3	7.498449973 × 10¹⁵
95-th percentile	9.501769457 × 10¹⁵
Maximum	9.999996297 × 10¹⁵
Range	9.999995676 × 10¹⁵
Interquartile range (IQR)	5.000261994 × 10¹⁵

Descriptive statistics

Standard deviation	2.88698754 × 10¹⁵
Coefficient of variation (CV)	0.5773717293
Kurtosis	-1.199361223
Mean	5.000223243 × 10¹⁵
Median Absolute Deviation (MAD)	2.500166606 × 10¹⁵
Skewness	0.0001303991867
Sum	8.13413659 × 10¹⁸
Variance	8.334697059 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.232155151 × 10¹⁵	4	< 0.1%
8.660267309 × 10¹⁵	4	< 0.1%
1.63763202 × 10¹⁵	4	< 0.1%
1.659987109 × 10¹⁵	4	< 0.1%
1.406367008 × 10¹⁵	4	< 0.1%
4.580296817 × 10¹⁵	4	< 0.1%
9.40633882 × 10¹⁵	4	< 0.1%
3.331892901 × 10¹⁵	4	< 0.1%
2.349371658 × 10¹⁵	4	< 0.1%
1.01012609 × 10¹⁵	4	< 0.1%
Other values (3944493)	9224547	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
621301964	2	< 0.1%
1746237949	2	< 0.1%
6567071234	4	< 0.1%
6785107154	2	< 0.1%
7632136837	2	< 0.1%
9680810241	4	< 0.1%
1.047700429 × 10¹⁰	2	< 0.1%
1.073433151 × 10¹⁰	2	< 0.1%
1.769053404 × 10¹⁰	2	< 0.1%
1.839801168 × 10¹⁰	2	< 0.1%

Value	Count	Frequency (%)
9.999996297 × 10¹⁵	2	< 0.1%
9.999994496 × 10¹⁵	4	< 0.1%
9.999993161 × 10¹⁵	4	< 0.1%
9.999991198 × 10¹⁵	1	< 0.1%
9.999988824 × 10¹⁵	2	< 0.1%
9.999980413 × 10¹⁵	4	< 0.1%
9.999980094 × 10¹⁵	2	< 0.1%
9.99997584 × 10¹⁵	2	< 0.1%
9.999972103 × 10¹⁵	2	< 0.1%
9.999958445 × 10¹⁵	4	< 0.1%

COUPON_NUMBER
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

1	3944455
2	3192507
3	1048568
4	1039057

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	1
3rd row	2
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
1	3944455	42.8%
2	3192507	34.6%
3	1048568	11.4%
4	1039057	11.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	3944455	42.8%
2	3192507	34.6%
3	1048568	11.4%
4	1039057	11.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

ORIGIN_AIRPORT_CODE
Categorical

HIGH CARDINALITY

Distinct	657
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

OUO	4077079
LFF	346275
EIE	182903
LFN	146284
VMX	143546
Other values (652)	4328500

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	103 ?
Unique (%)	< 0.1%

Sample

1st row	WXA
2nd row	OUO
3rd row	OUO
4th row	DZN
5th row	LFF

Common Values

Value	Count	Frequency (%)
OUO	4077079	44.2%
LFF	346275	3.8%
EIE	182903	2.0%
LFN	146284	1.6%
VMX	143546	1.6%
GMW	140460	1.5%
UGK	140279	1.5%
FBI	136799	1.5%
WXA	128991	1.4%
NTH	128869	1.4%
Other values (647)	3653102	39.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ouo	4077079	44.2%
lff	346275	3.8%
eie	182903	2.0%
lfn	146284	1.6%
vmx	143546	1.6%
gmw	140460	1.5%
ugk	140279	1.5%
fbi	136799	1.5%
wxa	128991	1.4%
nth	128869	1.4%
Other values (647)	3653102	39.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

DESTINATION_AIRPORT_CODE
Categorical

HIGH CARDINALITY

Distinct	679
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

OUO	4121121
LFF	325506
EIE	172335
LFN	149960
FBI	145271
Other values (674)	4310394

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	102 ?
Unique (%)	< 0.1%

Sample

1st row	OUO
2nd row	RRS
3rd row	HIX
4th row	OUO
5th row	NTH

Common Values

Value	Count	Frequency (%)
OUO	4121121	44.7%
LFF	325506	3.5%
EIE	172335	1.9%
LFN	149960	1.6%
FBI	145271	1.6%
UGK	144139	1.6%
GMW	141766	1.5%
VMX	140077	1.5%
HIX	129836	1.4%
UIT	129380	1.4%
Other values (669)	3625196	39.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ouo	4121121	44.7%
lff	325506	3.5%
eie	172335	1.9%
lfn	149960	1.6%
fbi	145271	1.6%
ugk	144139	1.6%
gmw	141766	1.5%
vmx	140077	1.5%
hix	129836	1.4%
uit	129380	1.4%
Other values (669)	3625196	39.3%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

FLIGHT_DATE_LOCAL
Categorical

HIGH CARDINALITY

Distinct	727
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

2007-09-21	34059
2007-09-14	33767
2007-09-17	33341
2007-09-28	32822
2007-09-24	32600
Other values (722)	9057998

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	2007-05-16
2nd row	2007-08-26
3rd row	2007-03-20
4th row	2007-04-08
5th row	2007-01-17

Common Values

Value	Count	Frequency (%)
2007-09-21	34059	0.4%
2007-09-14	33767	0.4%
2007-09-17	33341	0.4%
2007-09-28	32822	0.4%
2007-09-24	32600	0.4%
2007-08-10	32328	0.4%
2007-07-09	32304	0.4%
2007-09-10	32280	0.3%
2007-09-07	32212	0.3%
2007-07-20	32204	0.3%
Other values (717)	8896670	96.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2007-09-21	34059	0.4%
2007-09-14	33767	0.4%
2007-09-17	33341	0.4%
2007-09-28	32822	0.4%
2007-09-24	32600	0.4%
2007-08-10	32328	0.4%
2007-07-09	32304	0.4%
2007-09-10	32280	0.3%
2007-09-07	32212	0.3%
2007-07-20	32204	0.3%
Other values (717)	8896670	96.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TIME_DEPARTURE_LOCAL_TIME
Categorical

HIGH CARDINALITY

Distinct	1051
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	140.8 MiB

00:00:00	226887
19:50:00	200875
14:40:00	171883
16:45:00	164385
07:20:00	164203
Other values (1046)	8296352

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	85 ?
Unique (%)	< 0.1%

Sample

1st row	19:40:00
2nd row	13:55:00
3rd row	16:40:00
4th row	06:05:00
5th row	18:05:00

Common Values

Value	Count	Frequency (%)
00:00:00	226887	2.5%
19:50:00	200875	2.2%
14:40:00	171883	1.9%
16:45:00	164385	1.8%
07:20:00	164203	1.8%
14:55:00	150588	1.6%
17:05:00	146615	1.6%
19:45:00	133143	1.4%
16:30:00	128424	1.4%
19:40:00	127238	1.4%
Other values (1041)	7610344	82.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	226887	2.5%
19:50:00	200875	2.2%
14:40:00	171883	1.9%
16:45:00	164385	1.8%
07:20:00	164203	1.8%
14:55:00	150588	1.6%
17:05:00	146615	1.6%
19:45:00	133143	1.4%
16:30:00	128424	1.4%
19:40:00	127238	1.4%
Other values (1041)	7610344	82.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

FLIGHT_DISTANCE
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1688
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1814.180651

Minimum	0
Maximum	14507
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	0
5-th percentile	252
Q1	550
median	984
Q3	1460
95-th percentile	7521
Maximum	14507
Range	14507
Interquartile range (IQR)	910

Descriptive statistics

Standard deviation	2303.818296
Coefficient of variation (CV)	1.269894646
Kurtosis	3.009986926
Mean	1814.180651
Median Absolute Deviation (MAD)	447
Skewness	2.093692771
Sum	1.673506725 × 10¹⁰
Variance	5307578.742
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
246	405676	4.4%
1460	282015	3.1%
1344	255041	2.8%
1102	245560	2.7%
984	229948	2.5%
721	217810	2.4%
2511	217445	2.4%
402	214271	2.3%
1160	200195	2.2%
7521	194260	2.1%
Other values (1678)	6762366	73.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8	< 0.1%
9	2	< 0.1%
62	8	< 0.1%
90	135	< 0.1%
103	1	< 0.1%
108	1	< 0.1%
110	4	< 0.1%
117	2	< 0.1%
119	2	< 0.1%
128	9	< 0.1%

Value	Count	Frequency (%)
14507	1	< 0.1%
14131	4	< 0.1%
13175	1	< 0.1%
12466	1	< 0.1%
12240	6	< 0.1%
12178	2	< 0.1%
12005	1	< 0.1%
11497	1	< 0.1%
10890	2	< 0.1%
10869	1105	< 0.1%

FLIGHT_RANGE
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	2
Missing (%)	< 0.1%
Memory size	140.8 MiB

SHORT-HAUL	7061558
LONG-HAUL	1166541
DOMESTIC	996319
UNKNOWN	167

Length

Max length	10
Median length	10
Mean length	9.657471854
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SHORT-HAUL
2nd row	LONG-HAUL
3rd row	LONG-HAUL
4th row	SHORT-HAUL
5th row	SHORT-HAUL

Common Values

Value	Count	Frequency (%)
SHORT-HAUL	7061558	76.6%
LONG-HAUL	1166541	12.6%
DOMESTIC	996319	10.8%
UNKNOWN	167	< 0.1%
(Missing)	2	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
short-haul	7061558	76.6%
long-haul	1166541	12.6%
domestic	996319	10.8%
unknown	167	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

MARKETING_CARRIER
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	89
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.472350871 × 10¹⁵

Minimum	2.268751528 × 10¹⁴
Maximum	9.838732082 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	2.268751528 × 10¹⁴
5-th percentile	2.434615205 × 10¹⁵
Q1	2.434615205 × 10¹⁵
median	2.434615205 × 10¹⁵
Q3	2.434615205 × 10¹⁵
95-th percentile	2.434615205 × 10¹⁵
Maximum	9.838732082 × 10¹⁵
Range	9.611856929 × 10¹⁵
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4.36700163 × 10¹⁴
Coefficient of variation (CV)	0.176633571
Kurtosis	131.2053692
Mean	2.472350871 × 10¹⁵
Median Absolute Deviation (MAD)	0
Skewness	10.95075707
Sum	6.240027701 × 10¹⁸
Variance	1.907070324 × 10²⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.434615205 × 10¹⁵	9077702	98.4%
5.403774244 × 10¹⁵	25368	0.3%
2.099453761 × 10¹⁵	19567	0.2%
1.319526191 × 10¹⁵	11766	0.1%
7.495563552 × 10¹⁵	11634	0.1%
7.711540388 × 10¹⁵	7700	0.1%
4.849361541 × 10¹⁵	6952	0.1%
7.346940931 × 10¹⁵	6690	0.1%
3.858052475 × 10¹⁵	5809	0.1%
8.304362752 × 10¹⁵	5434	0.1%
Other values (79)	45965	0.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.268751528 × 10¹⁴	10	< 0.1%
2.455475406 × 10¹⁴	2923	< 0.1%
3.557699075 × 10¹⁴	214	< 0.1%
6.314863066 × 10¹⁴	342	< 0.1%
8.264698432 × 10¹⁴	16	< 0.1%
8.925619808 × 10¹⁴	284	< 0.1%
1.040662998 × 10¹⁵	59	< 0.1%
1.062886389 × 10¹⁵	20	< 0.1%
1.181685408 × 10¹⁵	9	< 0.1%
1.268037904 × 10¹⁵	1242	< 0.1%

Value	Count	Frequency (%)
9.838732082 × 10¹⁵	4	< 0.1%
9.76316395 × 10¹⁵	1529	< 0.1%
9.590400398 × 10¹⁵	127	< 0.1%
9.411423626 × 10¹⁵	1255	< 0.1%
9.379265973 × 10¹⁵	2	< 0.1%
9.265787999 × 10¹⁵	708	< 0.1%
9.228032722 × 10¹⁵	83	< 0.1%
8.804634256 × 10¹⁵	661	< 0.1%
8.642649904 × 10¹⁵	948	< 0.1%
8.511667559 × 10¹⁵	596	< 0.1%

OPERATIONAL_CARRIER
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	90
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.552896636 × 10¹⁵

Minimum	2.268751528 × 10¹⁴
Maximum	9.838732082 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	2.268751528 × 10¹⁴
5-th percentile	2.434615205 × 10¹⁵
Q1	2.434615205 × 10¹⁵
median	2.434615205 × 10¹⁵
Q3	2.434615205 × 10¹⁵
95-th percentile	2.434615205 × 10¹⁵
Maximum	9.838732082 × 10¹⁵
Range	9.611856929 × 10¹⁵
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.563456611 × 10¹⁴
Coefficient of variation (CV)	0.2962695985
Kurtosis	42.09296726
Mean	2.552896636 × 10¹⁵
Median Absolute Deviation (MAD)	0
Skewness	6.350476514
Sum	-7.075065803 × 10¹⁸
Variance	5.720587591 × 10²⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.434615205 × 10¹⁵	8870764	96.2%
5.403774244 × 10¹⁵	70623	0.8%
7.495563552 × 10¹⁵	42591	0.5%
4.676356572 × 10¹⁵	35092	0.4%
8.804634256 × 10¹⁵	31458	0.3%
2.099453761 × 10¹⁵	22353	0.2%
7.346940931 × 10¹⁵	19166	0.2%
6.990908407 × 10¹⁵	18889	0.2%
1.319526191 × 10¹⁵	14307	0.2%
1.711731043 × 10¹⁵	12613	0.1%
Other values (80)	86731	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.268751528 × 10¹⁴	10	< 0.1%
2.455475406 × 10¹⁴	5001	0.1%
3.557699075 × 10¹⁴	214	< 0.1%
6.314863066 × 10¹⁴	342	< 0.1%
8.264698432 × 10¹⁴	16	< 0.1%
8.925619808 × 10¹⁴	284	< 0.1%
1.040662998 × 10¹⁵	59	< 0.1%
1.062886389 × 10¹⁵	20	< 0.1%
1.181685408 × 10¹⁵	9	< 0.1%
1.268037904 × 10¹⁵	5228	0.1%

Value	Count	Frequency (%)
9.838732082 × 10¹⁵	4	< 0.1%
9.76316395 × 10¹⁵	1529	< 0.1%
9.590400398 × 10¹⁵	127	< 0.1%
9.411423626 × 10¹⁵	1255	< 0.1%
9.379265973 × 10¹⁵	2	< 0.1%
9.265787999 × 10¹⁵	707	< 0.1%
9.228032722 × 10¹⁵	83	< 0.1%
8.804634256 × 10¹⁵	31458	0.3%
8.642649904 × 10¹⁵	948	< 0.1%
8.511667559 × 10¹⁵	596	< 0.1%

BOOKED_CLASS
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

L	1208736
W	1159102
V	1008351
U	1000495
S	769101
Other values (21)	4078802

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	O
2nd row	U
3rd row	U
4th row	W
5th row	W

Common Values

Value	Count	Frequency (%)
L	1208736	13.1%
W	1159102	12.6%
V	1008351	10.9%
U	1000495	10.8%
S	769101	8.3%
T	707038	7.7%
O	703695	7.6%
Q	555528	6.0%
G	415344	4.5%
K	372493	4.0%
Other values (16)	1324704	14.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
l	1208736	13.1%
w	1159102	12.6%
v	1008351	10.9%
u	1000495	10.8%
s	769101	8.3%
t	707038	7.7%
o	703695	7.6%
q	555528	6.0%
g	415344	4.5%
k	372493	4.0%
Other values (15)	1324703	14.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKED_CABIN
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	140.8 MiB

Economy	8708423
Premium	280443
Business	235720

Length

Max length	8
Median length	7
Mean length	7.02555345
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Economy
2nd row	Economy
3rd row	Economy
4th row	Economy
5th row	Economy

Common Values

Value	Count	Frequency (%)
Economy	8708423	94.4%
Premium	280443	3.0%
Business	235720	2.6%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
economy	8708423	94.4%
premium	280443	3.0%
business	235720	2.6%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

AIRCRAFT_TYPE
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	65
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

DH4	1123835
E75	1091080
E95	895297
738	776429
788	715728
Other values (60)	4622218

Length

Max length	7
Median length	3
Mean length	3.073440253
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	738
2nd row	788
3rd row	788
4th row	E75
5th row	CRN

Common Values

Value	Count	Frequency (%)
DH4	1123835	12.2%
E75	1091080	11.8%
E95	895297	9.7%
738	776429	8.4%
788	715728	7.8%
CR9	691160	7.5%
7M8	640839	6.9%
E9A	557339	6.0%
E70	477442	5.2%
73H	435696	4.7%
Other values (55)	1819742	19.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
dh4	1123835	12.2%
e75	1091080	11.8%
e95	895297	9.7%
738	776429	8.4%
788	715728	7.8%
cr9	691160	7.5%
7m8	640839	6.9%
e9a	557339	6.0%
e70	477442	5.2%
73h	435696	4.7%
Other values (55)	1819742	19.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

FARE_BASIS
Categorical

HIGH CARDINALITY

Distinct	33211
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

GIT	222686
LSAVI0	95304
USAVI0	87918
OZSAVJ0	70761
VSAVK0	69933
Other values (33206)	8677985

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3759 ?
Unique (%)	< 0.1%

Sample

1st row	OZSTDJ0
2nd row	UKPRO10
3rd row	ULPRO11
4th row	WSTDK0
5th row	WCSERT/UD10

Common Values

Value	Count	Frequency (%)
GIT	222686	2.4%
LSAVI0	95304	1.0%
USAVI0	87918	1.0%
OZSAVJ0	70761	0.8%
VSAVK0	69933	0.8%
WSAVK0	69253	0.8%
WSAVI0	67337	0.7%
TLOSEA	65120	0.7%
VSTDK0	56695	0.6%
USAVG0	55945	0.6%
Other values (33201)	8363635	90.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
git	222696	2.4%
lsavi0	95309	1.0%
usavi0	87929	1.0%
ozsavj0	70778	0.8%
vsavk0	69936	0.8%
wsavk0	69258	0.8%
wsavi0	67349	0.7%
tlosea	65120	0.7%
vstdk0	56703	0.6%
usavg0	55970	0.6%
Other values (32329)	8368540	90.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

VAB
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

SAVER	3251123
STANDARD	2563924
OTHER	2098035
FLEX	699229
SEMI-FLEX	348690
Other values (2)	263586

Length

Max length	9
Median length	5
Mean length	5.938575028
Min length	4

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STANDARD
2nd row	BASIC
3rd row	BASIC
4th row	STANDARD
5th row	OTHER

Common Values

Value	Count	Frequency (%)
SAVER	3251123	35.2%
STANDARD	2563924	27.8%
OTHER	2098035	22.7%
FLEX	699229	7.6%
SEMI-FLEX	348690	3.8%
BASIC	195920	2.1%
FULL-FLEX	67666	0.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
saver	3251123	35.2%
standard	2563924	27.8%
other	2098035	22.7%
flex	699229	7.6%
semi-flex	348690	3.8%
basic	195920	2.1%
full-flex	67666	0.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

UPGRADED_FLAG
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 MiB

False	9215782
True	8805

Common Values
Chart

Value	Count	Frequency (%)
False	9215782	99.9%
True	8805	0.1%

UPGRADE_TYPE
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	0.1%
Missing	9215782
Missing (%)	99.9%
Memory size	140.8 MiB

lot upgrade	3397
upgrade	1966
upgrade at gate	1359
upg econ to premium	1046
upg econ to business	602

Length

Max length	23
Median length	11
Mean length	12.88279387
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	upg premium to business
2nd row	lot upgrade
3rd row	upgrade
4th row	lot upgrade
5th row	lot upgrade

Common Values

Value	Count	Frequency (%)
lot upgrade	3397	< 0.1%
upgrade	1966	< 0.1%
upgrade at gate	1359	< 0.1%
upg econ to premium	1046	< 0.1%
upg econ to business	602	< 0.1%
upg premium to business	435	< 0.1%
(Missing)	9215782	99.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
upgrade	6722	31.8%
lot	3397	16.0%
upg	2083	9.8%
to	2083	9.8%
econ	1648	7.8%
premium	1481	7.0%
at	1359	6.4%
gate	1359	6.4%
business	1037	4.9%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

UPGRADE_SALES_DATE
Categorical

HIGH CARDINALITY
MISSING

Distinct	481
Distinct (%)	5.5%
Missing	9215782
Missing (%)	99.9%
Memory size	140.8 MiB

2007-11-05	52
2007-10-15	52
2007-12-15	50
2007-09-25	49
2007-09-29	48
Other values (476)	8554

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	58 ?
Unique (%)	0.7%

Sample

1st row	2007-01-11
2nd row	2007-02-04
3rd row	2007-05-15
4th row	2007-01-24
5th row	2007-02-04

Common Values

Value	Count	Frequency (%)
2007-11-05	52	< 0.1%
2007-10-15	52	< 0.1%
2007-12-15	50	< 0.1%
2007-09-25	49	< 0.1%
2007-09-29	48	< 0.1%
2007-08-21	47	< 0.1%
2007-05-24	47	< 0.1%
2007-09-04	47	< 0.1%
2007-05-27	47	< 0.1%
2007-12-26	47	< 0.1%
Other values (471)	8319	0.1%
(Missing)	9215782	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2007-11-05	52	0.6%
2007-10-15	52	0.6%
2007-12-15	50	0.6%
2007-09-25	49	0.6%
2007-09-29	48	0.5%
2007-08-21	47	0.5%
2007-05-24	47	0.5%
2007-09-04	47	0.5%
2007-05-27	47	0.5%
2007-12-26	47	0.5%
Other values (471)	8319	94.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_ID
Real number (ℝ_≥0)

Distinct	2795940
Distinct (%)	30.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.999167484 × 10¹⁵

Minimum	1.4787909 × 10¹⁰
Maximum	9.999993604 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	1.4787909 × 10¹⁰
5-th percentile	4.996979081 × 10¹⁴
Q1	2.502587582 × 10¹⁵
median	4.995274085 × 10¹⁵
Q3	7.500628424 × 10¹⁵
95-th percentile	9.498853657 × 10¹⁵
Maximum	9.999993604 × 10¹⁵
Range	9.999978816 × 10¹⁵
Interquartile range (IQR)	4.998040842 × 10¹⁵

Descriptive statistics

Standard deviation	2.885806653 × 10¹⁵
Coefficient of variation (CV)	0.5772574459
Kurtosis	-1.199414561
Mean	4.999167484 × 10¹⁵
Median Absolute Deviation (MAD)	2.498697906 × 10¹⁵
Skewness	0.00160428563
Sum	-1.604802714 × 10¹⁸
Variance	8.327880039 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.814006325 × 10¹⁵	279	< 0.1%
6.413885912 × 10¹⁵	248	< 0.1%
9.330436931 × 10¹⁵	232	< 0.1%
8.124407744 × 10¹⁵	222	< 0.1%
9.20838413 × 10¹⁵	220	< 0.1%
4.073011969 × 10¹⁴	216	< 0.1%
5.503728085 × 10¹⁵	216	< 0.1%
9.845896655 × 10¹⁵	216	< 0.1%
2.741427892 × 10¹⁵	212	< 0.1%
5.469900034 × 10¹⁵	210	< 0.1%
Other values (2795930)	9222316	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.4787909 × 10¹⁰	2	< 0.1%
1.708659761 × 10¹⁰	4	< 0.1%
1.996479238 × 10¹⁰	2	< 0.1%
2.421156679 × 10¹⁰	2	< 0.1%
3.152591026 × 10¹⁰	4	< 0.1%
3.300183668 × 10¹⁰	2	< 0.1%
4.150214043 × 10¹⁰	4	< 0.1%
4.183495346 × 10¹⁰	4	< 0.1%
4.396179757 × 10¹⁰	8	< 0.1%
4.641041529 × 10¹⁰	16	< 0.1%

Value	Count	Frequency (%)
9.999993604 × 10¹⁵	2	< 0.1%
9.999991575 × 10¹⁵	2	< 0.1%
9.999988806 × 10¹⁵	4	< 0.1%
9.99998833 × 10¹⁵	4	< 0.1%
9.999985817 × 10¹⁵	8	< 0.1%
9.999985519 × 10¹⁵	2	< 0.1%
9.999982392 × 10¹⁵	2	< 0.1%
9.99998141 × 10¹⁵	2	< 0.1%
9.999970594 × 10¹⁵	2	< 0.1%
9.999969169 × 10¹⁵	2	< 0.1%

ORIGINAL_TICKET_NUMBER
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	3310
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.376164102 × 10¹⁵

Minimum	2.334519661 × 10¹²
Maximum	9.998792831 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	2.334519661 × 10¹²
5-th percentile	9.379265973 × 10¹⁵
Q1	9.379265973 × 10¹⁵
median	9.379265973 × 10¹⁵
Q3	9.379265973 × 10¹⁵
95-th percentile	9.379265973 × 10¹⁵
Maximum	9.998792831 × 10¹⁵
Range	9.996458311 × 10¹⁵
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.395686988 × 10¹⁴
Coefficient of variation (CV)	0.01488547953
Kurtosis	2696.179345
Mean	9.376164102 × 10¹⁵
Median Absolute Deviation (MAD)	0
Skewness	-50.30191515
Sum	-5.541480552 × 10¹⁸
Variance	1.94794217 × 10²⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.379265973 × 10¹⁵	9218034	99.9%
3.981966873 × 10¹⁵	10	< 0.1%
7.971162458 × 10¹³	10	< 0.1%
1.306124545 × 10¹⁵	10	< 0.1%
8.460182694 × 10¹⁵	10	< 0.1%
4.834231548 × 10¹⁵	8	< 0.1%
7.62507682 × 10¹⁵	8	< 0.1%
9.568725185 × 10¹⁵	8	< 0.1%
1.721215489 × 10¹⁵	7	< 0.1%
6.82357158 × 10¹⁵	6	< 0.1%
Other values (3300)	6476	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.334519661 × 10¹²	2	< 0.1%
8.145144489 × 10¹²	2	< 0.1%
1.002984636 × 10¹³	1	< 0.1%
1.368096309 × 10¹³	1	< 0.1%
2.110182871 × 10¹³	2	< 0.1%
2.173339016 × 10¹³	4	< 0.1%
4.265450911 × 10¹³	4	< 0.1%
4.373848398 × 10¹³	1	< 0.1%
4.55339565 × 10¹³	2	< 0.1%
4.70488326 × 10¹³	2	< 0.1%

Value	Count	Frequency (%)
9.998792831 × 10¹⁵	1	< 0.1%
9.99759638 × 10¹⁵	2	< 0.1%
9.995602871 × 10¹⁵	2	< 0.1%
9.995032605 × 10¹⁵	2	< 0.1%
9.993920037 × 10¹⁵	2	< 0.1%
9.987224125 × 10¹⁵	1	< 0.1%
9.976617261 × 10¹⁵	1	< 0.1%
9.975232462 × 10¹⁵	2	< 0.1%
9.962332105 × 10¹⁵	1	< 0.1%
9.961439234 × 10¹⁵	1	< 0.1%

FORM_OF_PAYMENT
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	79
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

CA	3181526
CCCA5	2552070
CCVI4	1706369
CCAX3	720072
CCTP1	270349
Other values (74)	794201

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CA
2nd row	CA
3rd row	CCVI4
4th row	CA
5th row	CA

Common Values

Value	Count	Frequency (%)
CA	3181526	34.5%
CCCA5	2552070	27.7%
CCVI4	1706369	18.5%
CCAX3	720072	7.8%
CCTP1	270349	2.9%
DOTPA	235214	2.5%
PAYPA	168891	1.8%
CCDC3	120727	1.3%
INVOI	103639	1.1%
INTER	38002	0.4%
Other values (69)	127728	1.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	3181526	34.5%
ccca5	2552070	27.7%
ccvi4	1706369	18.5%
ccax3	720072	7.8%
cctp1	270349	2.9%
dotpa	235214	2.5%
paypa	168891	1.8%
ccdc3	120727	1.3%
invoi	103639	1.1%
inter	38002	0.4%
Other values (70)	131488	1.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CURRENCY
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	38
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

EUR	2981011
PLN	2323316
USD	1142780
SEK	597344
UAH	315625
Other values (33)	1864511

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PLN
2nd row	EUR
3rd row	USD
4th row	UAH
5th row	EUR

Common Values

Value	Count	Frequency (%)
EUR	2981011	32.3%
PLN	2323316	25.2%
USD	1142780	12.4%
SEK	597344	6.5%
UAH	315625	3.4%
RUB	273962	3.0%
GBP	271065	2.9%
CAD	234220	2.5%
KRW	155622	1.7%
DKK	122084	1.3%
Other values (28)	807558	8.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
eur	2981011	32.3%
pln	2323316	25.2%
usd	1142780	12.4%
sek	597344	6.5%
uah	315625	3.4%
rub	273962	3.0%
gbp	271065	2.9%
cad	234220	2.5%
krw	155622	1.7%
dkk	122084	1.3%
Other values (27)	807529	8.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TOTAL_PRICE
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct	363032
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25080.2803

Minimum	-1564.6
Maximum	107910000
Zeros	4226
Zeros (%)	< 0.1%
Negative	3
Negative (%)	< 0.1%
Memory size	140.8 MiB

Quantile statistics

Minimum	-1564.6
5-th percentile	130.99
Q1	280.11
median	786.14
Q3	1819
95-th percentile	23907
Maximum	107910000
Range	107911564.6
Interquartile range (IQR)	1538.89

Descriptive statistics

Standard deviation	223500.6036
Coefficient of variation (CV)	8.911407724
Kurtosis	38421.76424
Mean	25080.2803
Median Absolute Deviation (MAD)	560.67
Skewness	117.8490263
Sum	2.313552276 × 10¹¹
Variance	4.995251981 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4226	< 0.1%
240	2720	< 0.1%
229.34	1994	< 0.1%
99.9	1866	< 0.1%
189.52	1695	< 0.1%
209.34	1679	< 0.1%
980	1598	< 0.1%
156.21	1532	< 0.1%
2532	1395	< 0.1%
190.6	1384	< 0.1%
Other values (363022)	9204498	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1564.6	3	< 0.1%
0	4226	< 0.1%
0.03	2	< 0.1%
0.04	2	< 0.1%
0.08	2	< 0.1%
0.1	2	< 0.1%
0.2	4	< 0.1%
0.53	28	< 0.1%
0.6	1	< 0.1%
1	62	< 0.1%

Value	Count	Frequency (%)
107910000	4	< 0.1%
71512000	2	< 0.1%
64537000	3	< 0.1%
59452000	2	< 0.1%
58939000	4	< 0.1%
57872000	2	< 0.1%
55412000	6	< 0.1%
50779000	8	< 0.1%
37874000	2	< 0.1%
35501000	2	< 0.1%

TOTAL_PRICE_PLN
Real number (ℝ)

HIGH CORRELATION

Distinct	473960
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1688.65867

Minimum	-5328.25
Maximum	49075.99
Zeros	4226
Zeros (%)	< 0.1%
Negative	3
Negative (%)	< 0.1%
Memory size	140.8 MiB

Quantile statistics

Minimum	-5328.25
5-th percentile	432.78
Q1	782.51
median	1162.92
Q3	2052
95-th percentile	4336.297
Maximum	49075.99
Range	54404.24
Interquartile range (IQR)	1269.49

Descriptive statistics

Standard deviation	1672.056032
Coefficient of variation (CV)	0.9901681501
Kurtosis	34.25929433
Mean	1688.65867
Median Absolute Deviation (MAD)	481.36
Skewness	4.427305766
Sum	1.557717882 × 10¹⁰
Variance	2795771.373
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4226	< 0.1%
60.59	1150	< 0.1%
1371.08	965	< 0.1%
1239.49	828	< 0.1%
429.79	563	< 0.1%
399.43	400	< 0.1%
1429.81	381	< 0.1%
349.07	375	< 0.1%
3211.84	339	< 0.1%
1759.05	318	< 0.1%
Other values (473950)	9215042	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-5328.25	3	< 0.1%
0	4226	< 0.1%
0.03	2	< 0.1%
0.08	2	< 0.1%
0.17	2	< 0.1%
0.2	3	< 0.1%
0.43	2	< 0.1%
0.67	1	< 0.1%
0.85	1	< 0.1%
0.9	4	< 0.1%

Value	Count	Frequency (%)
49075.99	4	< 0.1%
48898.13	4	< 0.1%
42351.54	4	< 0.1%
40716.98	4	< 0.1%
40447.81	3	< 0.1%
40301.44	4	< 0.1%
37710.93	3	< 0.1%
35749.98	6	< 0.1%
35723.83	4	< 0.1%
35681.94	4	< 0.1%

PAX_GENDER
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

M	6549164
F	2675423

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	F
4th row	F
5th row	M

Common Values

Value	Count	Frequency (%)
M	6549164	71.0%
F	2675423	29.0%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
m	6549164	71.0%
f	2675423	29.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

PAX_TYPE
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

ADULT	9045461
CHILD	144947
INFANT	34179

Length

Max length	6
Median length	5
Mean length	5.003705207
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ADULT
2nd row	ADULT
3rd row	ADULT
4th row	ADULT
5th row	ADULT

Common Values

Value	Count	Frequency (%)
ADULT	9045461	98.1%
CHILD	144947	1.6%
INFANT	34179	0.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
adult	9045461	98.1%
child	144947	1.6%
infant	34179	0.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CORPORATE_CONTRACT_FLG
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 MiB

False	8952085
True	272502

Common Values
Chart

Value	Count	Frequency (%)
False	8952085	97.0%
True	272502	3.0%

LOYAL_CUSTOMER
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 MiB

False	7840881
True	1383706

Common Values
Chart

Value	Count	Frequency (%)
False	7840881	85.0%
True	1383706	15.0%

LOYAL_CUSTOMER_ID
Real number (ℝ_≥0)

MISSING

Distinct	265358
Distinct (%)	19.2%
Missing	7840881
Missing (%)	85.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.984529267 × 10¹⁵

Minimum	1.389848426 × 10¹⁰
Maximum	9.999998028 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	1.389848426 × 10¹⁰
5-th percentile	4.887175725 × 10¹⁴
Q1	2.483612606 × 10¹⁵
median	4.977264159 × 10¹⁵
Q3	7.484234464 × 10¹⁵
95-th percentile	9.490646602 × 10¹⁵
Maximum	9.999998028 × 10¹⁵
Range	9.999984129 × 10¹⁵
Interquartile range (IQR)	5.000621858 × 10¹⁵

Descriptive statistics

Standard deviation	2.889320868 × 10¹⁵
Coefficient of variation (CV)	0.5796577196
Kurtosis	-1.198005069
Mean	4.984529267 × 10¹⁵
Median Absolute Deviation (MAD)	2.501096772 × 10¹⁵
Skewness	0.005668665518
Sum	6.897123054 × 10²¹
Variance	8.34817508 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.910455974 × 10¹⁵	216	< 0.1%
7.649390971 × 10¹⁵	171	< 0.1%
6.057484602 × 10¹⁵	160	< 0.1%
8.30918744 × 10¹⁴	158	< 0.1%
5.789314198 × 10¹⁴	155	< 0.1%
9.922290221 × 10¹⁵	150	< 0.1%
7.052728341 × 10¹⁵	148	< 0.1%
8.957362722 × 10¹⁵	144	< 0.1%
4.953263798 × 10¹⁵	144	< 0.1%
3.020371903 × 10¹⁵	141	< 0.1%
Other values (265348)	1382119	15.0%
(Missing)	7840881	85.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.389848426 × 10¹⁰	2	< 0.1%
1.695067404 × 10¹¹	4	< 0.1%
1.790219526 × 10¹¹	21	< 0.1%
2.267783645 × 10¹¹	6	< 0.1%
2.567251252 × 10¹¹	4	< 0.1%
2.608901449 × 10¹¹	4	< 0.1%
3.200981632 × 10¹¹	1	< 0.1%
3.645997832 × 10¹¹	4	< 0.1%
3.795908228 × 10¹¹	1	< 0.1%
4.320790139 × 10¹¹	14	< 0.1%

Value	Count	Frequency (%)
9.999998028 × 10¹⁵	2	< 0.1%
9.999983475 × 10¹⁵	1	< 0.1%
9.999910337 × 10¹⁵	4	< 0.1%
9.999840581 × 10¹⁵	4	< 0.1%
9.999808045 × 10¹⁵	2	< 0.1%
9.999776868 × 10¹⁵	2	< 0.1%
9.999767465 × 10¹⁵	9	< 0.1%
9.999753454 × 10¹⁵	4	< 0.1%
9.999691793 × 10¹⁵	8	< 0.1%
9.999579353 × 10¹⁵	6	< 0.1%

LOYAL_CUSTOMER_DATE_OF_BIRTH
Categorical

HIGH CARDINALITY
MISSING

Distinct	24920
Distinct (%)	1.8%
Missing	7848547
Missing (%)	85.1%
Memory size	140.8 MiB

1964-04-20	358
1967-08-25	358
1969-07-18	332
1971-05-21	326
1960-11-23	309
Other values (24915)	1374357

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	222 ?
Unique (%)	< 0.1%

Sample

1st row	1961-03-26
2nd row	1979-09-12
3rd row	1951-10-15
4th row	1943-11-01
5th row	1966-07-04

Common Values

Value	Count	Frequency (%)
1964-04-20	358	< 0.1%
1967-08-25	358	< 0.1%
1969-07-18	332	< 0.1%
1971-05-21	326	< 0.1%
1960-11-23	309	< 0.1%
1967-03-03	305	< 0.1%
1966-07-21	304	< 0.1%
1970-12-20	304	< 0.1%
1970-06-12	302	< 0.1%
1967-04-14	302	< 0.1%
Other values (24910)	1372840	14.9%
(Missing)	7848547	85.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1964-04-20	358	< 0.1%
1967-08-25	358	< 0.1%
1969-07-18	332	< 0.1%
1971-05-21	326	< 0.1%
1960-11-23	309	< 0.1%
1967-03-03	305	< 0.1%
1966-07-21	304	< 0.1%
1970-12-20	304	< 0.1%
1970-06-12	302	< 0.1%
1967-04-14	302	< 0.1%
Other values (24910)	1372840	99.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

LOYAL_CUSTOMER_REGISTERED_DATE
Categorical

HIGH CARDINALITY
MISSING

Distinct	8930
Distinct (%)	0.6%
Missing	7840881
Missing (%)	85.0%
Memory size	140.8 MiB

1991-12-01	19093
1991-11-30	10357
1991-12-03	7600
1991-11-29	5689
1996-06-14	4776
Other values (8925)	1336191

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	35 ?
Unique (%)	< 0.1%

Sample

1st row	1996-06-13
2nd row	2006-10-22
3rd row	1986-04-03
4th row	1988-05-27
5th row	2003-11-21

Common Values

Value	Count	Frequency (%)
1991-12-01	19093	0.2%
1991-11-30	10357	0.1%
1991-12-03	7600	0.1%
1991-11-29	5689	0.1%
1996-06-14	4776	0.1%
1996-06-13	4724	0.1%
1992-02-18	4149	< 0.1%
1996-08-20	4147	< 0.1%
1992-02-20	3318	< 0.1%
1996-06-24	2828	< 0.1%
Other values (8920)	1317025	14.3%
(Missing)	7840881	85.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1991-12-01	19093	1.4%
1991-11-30	10357	0.7%
1991-12-03	7600	0.5%
1991-11-29	5689	0.4%
1996-06-14	4776	0.3%
1996-06-13	4724	0.3%
1992-02-18	4149	0.3%
1996-08-20	4147	0.3%
1992-02-20	3318	0.2%
1996-06-24	2828	0.2%
Other values (8920)	1317025	95.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

SALES_DATE
Categorical

HIGH CARDINALITY

Distinct	365
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

2007-01-10	56382
2007-01-11	46672
2007-01-12	45940
2007-01-23	43905
2007-01-16	42545
Other values (360)	8989143

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2007-01-11
2nd row	2007-01-10
3rd row	2007-01-10
4th row	2007-03-27
5th row	2007-01-10

Common Values

Value	Count	Frequency (%)
2007-01-10	56382	0.6%
2007-01-11	46672	0.5%
2007-01-12	45940	0.5%
2007-01-23	43905	0.5%
2007-01-16	42545	0.5%
2007-01-17	41739	0.5%
2007-01-15	41155	0.4%
2007-01-19	40698	0.4%
2007-01-22	40018	0.4%
2007-04-10	39449	0.4%
Other values (355)	8786084	95.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2007-01-10	56382	0.6%
2007-01-11	46672	0.5%
2007-01-12	45940	0.5%
2007-01-23	43905	0.5%
2007-01-16	42545	0.5%
2007-01-17	41739	0.5%
2007-01-15	41155	0.4%
2007-01-19	40698	0.4%
2007-01-22	40018	0.4%
2007-04-10	39449	0.4%
Other values (355)	8786084	95.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

SALES_MARKET
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	72
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.451603946 × 10¹⁵

Minimum	1.436722689 × 10¹⁴
Maximum	9.831241332 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	1.436722689 × 10¹⁴
5-th percentile	1.319526191 × 10¹⁵
Q1	2.460355647 × 10¹⁵
median	4.676356572 × 10¹⁵
Q3	5.918065357 × 10¹⁵
95-th percentile	7.445666649 × 10¹⁵
Maximum	9.831241332 × 10¹⁵
Range	9.687569063 × 10¹⁵
Interquartile range (IQR)	3.45770971 × 10¹⁵

Descriptive statistics

Standard deviation	2.111584968 × 10¹⁵
Coefficient of variation (CV)	0.4743425053
Kurtosis	-0.514131839
Mean	4.451603946 × 10¹⁵
Median Absolute Deviation (MAD)	2.216000925 × 10¹⁵
Skewness	0.2752812975
Sum	1.755584477 × 10¹⁸
Variance	4.458791079 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.460355647 × 10¹⁵	2323721	25.2%
6.982998843 × 10¹⁵	956026	10.4%
5.492600423 × 10¹⁵	760762	8.2%
3.823004278 × 10¹⁵	597118	6.5%
4.676356572 × 10¹⁵	335815	3.6%
1.319526191 × 10¹⁵	315543	3.4%
5.218436845 × 10¹⁵	273820	3.0%
5.703060121 × 10¹⁵	272958	3.0%
6.745023307 × 10¹⁵	271118	2.9%
4.680091206 × 10¹⁵	251416	2.7%
Other values (62)	2866290	31.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.436722689 × 10¹⁴	3277	< 0.1%
2.200278881 × 10¹⁴	42501	0.5%
4.272004361 × 10¹⁴	86565	0.9%
4.346767962 × 10¹⁴	101387	1.1%
5.522629473 × 10¹⁴	14012	0.2%
1.040662998 × 10¹⁵	593	< 0.1%
1.268037904 × 10¹⁵	86422	0.9%
1.319526191 × 10¹⁵	315543	3.4%
1.51438236 × 10¹⁵	53419	0.6%
2.099453761 × 10¹⁵	48389	0.5%

Value	Count	Frequency (%)
9.831241332 × 10¹⁵	159103	1.7%
9.509246387 × 10¹⁵	4178	< 0.1%
9.475875089 × 10¹⁵	15739	0.2%
9.306828478 × 10¹⁵	33583	0.4%
9.265787999 × 10¹⁵	95950	1.0%
9.172083597 × 10¹⁵	195	< 0.1%
9.071749734 × 10¹⁵	57	< 0.1%
8.666019511 × 10¹⁵	14392	0.2%
8.642649904 × 10¹⁵	729	< 0.1%
8.557423498 × 10¹⁵	25400	0.3%

SALES_CHANNEL
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

AGENTS	6243016
LOT.COM	2607855
ATO_CTO	194883
CALL CENTER	122432
LOT TRAVEL	56342

Length

Max length	11
Median length	6
Mean length	6.39460726
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LOT TRAVEL
2nd row	AGENTS
3rd row	LOT.COM
4th row	AGENTS
5th row	AGENTS

Common Values

Value	Count	Frequency (%)
AGENTS	6243016	67.7%
LOT.COM	2607855	28.3%
ATO_CTO	194883	2.1%
CALL CENTER	122432	1.3%
LOT TRAVEL	56342	0.6%
DCS	59	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
agents	6243016	66.4%
lot.com	2607855	27.7%
ato_cto	194883	2.1%
call	122432	1.3%
center	122432	1.3%
lot	56342	0.6%
travel	56342	0.6%
dcs	59	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

TRIP_TYPE
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

ROUND TRIP	6257485
ONE WAY	1796410
MULTICITY	1170692

Length

Max length	10
Median length	10
Mean length	9.288865507
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ROUND TRIP
2nd row	ROUND TRIP
3rd row	ROUND TRIP
4th row	ROUND TRIP
5th row	ROUND TRIP

Common Values

Value	Count	Frequency (%)
ROUND TRIP	6257485	67.8%
ONE WAY	1796410	19.5%
MULTICITY	1170692	12.7%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
round	6257485	36.2%
trip	6257485	36.2%
one	1796410	10.4%
way	1796410	10.4%
multicity	1170692	6.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_WINDOW_D
Real number (ℝ)

ZEROS

Distinct	365
Distinct (%)	< 0.1%
Missing	438
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	44.30218668

Minimum	-1
Maximum	365
Zeros	166525
Zeros (%)	1.8%
Negative	6569
Negative (%)	0.1%
Memory size	140.8 MiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	7
median	22
Q3	58
95-th percentile	168
Maximum	365
Range	366
Interquartile range (IQR)	51

Descriptive statistics

Standard deviation	56.14017749
Coefficient of variation (CV)	1.267210079
Kurtosis	4.990335168
Mean	44.30218668
Median Absolute Deviation (MAD)	17
Skewness	2.131762129
Sum	408649971
Variance	3151.719529
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	374643	4.1%
7	309574	3.4%
2	307512	3.3%
5	305500	3.3%
3	298851	3.2%
4	293911	3.2%
6	288406	3.1%
8	224411	2.4%
10	198027	2.1%
11	187889	2.0%
Other values (355)	6435425	69.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	6569	0.1%
0	166525	1.8%
1	374643	4.1%
2	307512	3.3%
3	298851	3.2%
4	293911	3.2%
5	305500	3.3%
6	288406	3.1%
7	309574	3.4%
8	224411	2.4%

Value	Count	Frequency (%)
365	35	< 0.1%
364	12	< 0.1%
361	131	< 0.1%
360	118	< 0.1%
359	175	< 0.1%
358	141	< 0.1%
357	236	< 0.1%
356	173	< 0.1%
355	131	< 0.1%
354	219	< 0.1%

STAY_LENGTH_D
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	367
Distinct (%)	< 0.1%
Missing	424
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-1937.802156

Minimum	-9999
Maximum	366
Zeros	321065
Zeros (%)	3.5%
Negative	1796410
Negative (%)	19.5%
Memory size	140.8 MiB

Quantile statistics

Minimum	-9999
5-th percentile	-9999
Q1	1
median	4
Q3	9
95-th percentile	33
Maximum	366
Range	10365
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3964.422267
Coefficient of variation (CV)	-2.045834377
Kurtosis	0.3764763633
Mean	-1937.802156
Median Absolute Deviation (MAD)	4
Skewness	-1.541520623
Sum	-1.787460295 × 10¹⁰
Variance	15716643.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-9999	1796410	19.5%
2	912232	9.9%
3	911736	9.9%
4	686238	7.4%
1	595092	6.5%
7	435882	4.7%
5	421307	4.6%
6	350153	3.8%
0	321065	3.5%
8	303715	3.3%
Other values (357)	2490333	27.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-9999	1796410	19.5%
0	321065	3.5%
1	595092	6.5%
2	912232	9.9%
3	911736	9.9%
4	686238	7.4%
5	421307	4.6%
6	350153	3.8%
7	435882	4.7%
8	303715	3.3%

Value	Count	Frequency (%)
366	6	< 0.1%
365	46	< 0.1%
364	7	< 0.1%
362	2	< 0.1%
361	4	< 0.1%
360	20	< 0.1%
359	18	< 0.1%
358	77	< 0.1%
357	14	< 0.1%
356	44	< 0.1%

BOOKING_LONG_HOUL_FLAG
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 MiB

False	7243975
True	1980612

Common Values
Chart

Value	Count	Frequency (%)
False	7243975	78.5%
True	1980612	21.5%

BOOKING_DOMESTIC_FLAG
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	79.2 MiB

False	9223406
True	1181

Common Values
Chart

Value	Count	Frequency (%)
False	9223406	> 99.9%
True	1181	< 0.1%

FLIGHT_COUPONS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	155
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.950106059

Minimum	1
Maximum	315
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	4
Q3	8
95-th percentile	20
Maximum	315
Range	314
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	16.47474572
Coefficient of variation (CV)	2.072267413
Kurtosis	49.09842659
Mean	7.950106059
Median Absolute Deviation (MAD)	2
Skewness	6.224773058
Sum	73336445
Variance	271.4172464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	2999775	32.5%
2	2559332	27.7%
8	1174648	12.7%
1	460980	5.0%
6	428625	4.6%
12	385880	4.2%
16	238396	2.6%
3	205973	2.2%
10	96752	1.0%
20	87102	0.9%
Other values (145)	587124	6.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	460980	5.0%
2	2559332	27.7%
3	205973	2.2%
4	2999775	32.5%
5	24073	0.3%
6	428625	4.6%
7	5114	0.1%
8	1174648	12.7%
9	28140	0.3%
10	96752	1.0%

Value	Count	Frequency (%)
315	189	< 0.1%
279	279	< 0.1%
268	201	< 0.1%
265	159	< 0.1%
248	248	< 0.1%
235	141	< 0.1%
232	232	< 0.1%
222	222	< 0.1%
220	220	< 0.1%
216	810	< 0.1%

SEGMENTS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.806591124

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	2
Maximum	10
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.458649842
Coefficient of variation (CV)	0.2538758416
Kurtosis	1.324028627
Mean	1.806591124
Median Absolute Deviation (MAD)	0
Skewness	-0.5650081206
Sum	16665057
Variance	0.2103596776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
2	6972663	75.6%
1	2023111	21.9%
3	219421	2.4%
4	8941	0.1%
5	311	< 0.1%
6	57	< 0.1%
7	34	< 0.1%
10	33	< 0.1%
8	16	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2023111	21.9%
2	6972663	75.6%
3	219421	2.4%
4	8941	0.1%
5	311	< 0.1%
6	57	< 0.1%
7	34	< 0.1%
8	16	< 0.1%
10	33	< 0.1%

Value	Count	Frequency (%)
10	33	< 0.1%
8	16	< 0.1%
7	34	< 0.1%
6	57	< 0.1%
5	311	< 0.1%
4	8941	0.1%
3	219421	2.4%
2	6972663	75.6%
1	2023111	21.9%

PAX_N
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	90
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.91961342

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	140.8 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	8
Maximum	99
Range	98
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	6.056848711
Coefficient of variation (CV)	2.074537906
Kurtosis	45.7372056
Mean	2.91961342
Median Absolute Deviation (MAD)	0
Skewness	6.115811801
Sum	26932228
Variance	36.68541631
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5034103	54.6%
2	2129340	23.1%
3	725200	7.9%
4	514854	5.6%
5	191594	2.1%
6	105102	1.1%
7	55056	0.6%
8	47960	0.5%
9	47758	0.5%
30	18156	0.2%
Other values (80)	355464	3.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5034103	54.6%
2	2129340	23.1%
3	725200	7.9%
4	514854	5.6%
5	191594	2.1%
6	105102	1.1%
7	55056	0.6%
8	47960	0.5%
9	47758	0.5%
10	16692	0.2%

Value	Count	Frequency (%)
99	297	< 0.1%
98	98	< 0.1%
96	96	< 0.1%
92	279	< 0.1%
90	360	< 0.1%
89	89	< 0.1%
88	176	< 0.1%
86	258	< 0.1%
85	170	< 0.1%
83	166	< 0.1%

INTINERARY
Categorical

HIGH CARDINALITY

Distinct	55794
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

XMK-OUO-XMK	77197
OUO-FBI-OUO	72312
OUO-UGK-OUO	67890
OUO-WXA-OUO	66542
LFN-OUO-LFN	61912
Other values (55789)	8878734

Length

Max length	35
Median length	11
Mean length	14.47592906
Min length	7

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7 ?
Unique (%)	< 0.1%

Sample

1st row	OUO-WXA-OUO
2nd row	OUO-RRS-OUO
3rd row	HIX-OUO-HIX
4th row	DZN-OUO-LPF-OUO-EVJ
5th row	NTH-LFF-NTH

Common Values

Value	Count	Frequency (%)
XMK-OUO-XMK	77197	0.8%
OUO-FBI-OUO	72312	0.8%
OUO-UGK-OUO	67890	0.7%
OUO-WXA-OUO	66542	0.7%
LFN-OUO-LFN	61912	0.7%
OUO-VWT-OUO	55118	0.6%
FBI-OUO-FBI	49108	0.5%
OUO-VIM-OUO	43878	0.5%
OUO-VMX-OUO	40511	0.4%
OUO-GMW-OUO	37334	0.4%
Other values (55784)	8652785	93.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
xmk-ouo-xmk	77197	0.8%
ouo-fbi-ouo	72312	0.8%
ouo-ugk-ouo	67890	0.7%
ouo-wxa-ouo	66542	0.7%
lfn-ouo-lfn	61912	0.7%
ouo-vwt-ouo	55118	0.6%
fbi-ouo-fbi	49108	0.5%
ouo-vim-ouo	43878	0.5%
ouo-vmx-ouo	40511	0.4%
ouo-gmw-ouo	37334	0.4%
Other values (55784)	8652785	93.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_ORIGIN_AIRPORT
Categorical

HIGH CARDINALITY

Distinct	145
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

OUO	1866644
LFF	455128
EIE	278176
HIX	236747
NTH	217121
Other values (140)	6170771

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OUO
2nd row	OUO
3rd row	HIX
4th row	DZN
5th row	NTH

Common Values

Value	Count	Frequency (%)
OUO	1866644	20.2%
LFF	455128	4.9%
EIE	278176	3.0%
HIX	236747	2.6%
NTH	217121	2.4%
LFN	212850	2.3%
CYE	201002	2.2%
FBI	195876	2.1%
XMK	193526	2.1%
UGK	182378	2.0%
Other values (135)	5185139	56.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ouo	1866644	20.2%
lff	455128	4.9%
eie	278176	3.0%
hix	236747	2.6%
nth	217121	2.4%
lfn	212850	2.3%
cye	201002	2.2%
fbi	195876	2.1%
xmk	193526	2.1%
ugk	182378	2.0%
Other values (135)	5185139	56.2%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_ORIGIN_COUNTRY_CODE
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	140.8 MiB

PL	2901845
DE	832391
US	591713
UA	468357
EE	455128
Other values (46)	3975150

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PL
2nd row	PL
3rd row	US
4th row	UA
5th row	LT

Common Values

Value	Count	Frequency (%)
PL	2901845	31.5%
DE	832391	9.0%
US	591713	6.4%
UA	468357	5.1%
EE	455128	4.9%
SE	249853	2.7%
LT	244425	2.6%
NL	216992	2.4%
IL	212850	2.3%
FR	206603	2.2%
Other values (41)	2844427	30.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pl	2901845	31.5%
de	832391	9.0%
us	591713	6.4%
ua	468357	5.1%
ee	455128	4.9%
se	249853	2.7%
lt	244425	2.6%
nl	216992	2.4%
il	212850	2.3%
fr	206603	2.2%
Other values (41)	2844427	30.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_DEPARTURE_TIME_UTC
Categorical

HIGH CARDINALITY

Distinct	83698
Distinct (%)	0.9%
Missing	438
Missing (%)	< 0.1%
Memory size	140.8 MiB

2007-08-03 02:05:00	1910
2007-07-15 17:50:00	1867
2007-07-09 02:05:00	1712
2007-06-28 02:05:00	1683
2007-04-30 02:05:00	1614
Other values (83693)	9215363

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1345 ?
Unique (%)	< 0.1%

Sample

1st row	2007-05-12 05:25:00
2nd row	2007-08-26 11:55:00
3rd row	2007-03-06 03:35:00
4th row	2007-04-08 03:05:00
5th row	2007-01-16 17:35:00

Common Values

Value	Count	Frequency (%)
2007-08-03 02:05:00	1910	< 0.1%
2007-07-15 17:50:00	1867	< 0.1%
2007-07-09 02:05:00	1712	< 0.1%
2007-06-28 02:05:00	1683	< 0.1%
2007-04-30 02:05:00	1614	< 0.1%
2007-07-21 02:05:00	1539	< 0.1%
2007-09-21 02:05:00	1513	< 0.1%
2007-07-05 02:05:00	1487	< 0.1%
2007-12-21 09:25:00	1479	< 0.1%
2007-07-13 08:25:00	1478	< 0.1%
Other values (83688)	9207867	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
08:25:00	199168	1.1%
02:05:00	176140	1.0%
17:50:00	149657	0.8%
12:55:00	147078	0.8%
05:00:00	140003	0.8%
05:30:00	124182	0.7%
01:55:00	123850	0.7%
08:45:00	119544	0.6%
08:30:00	115082	0.6%
05:20:00	106939	0.6%
Other values (1117)	17046655	92.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_DESTINATION_AIRPORT
Categorical

HIGH CARDINALITY
MISSING

Distinct	147
Distinct (%)	< 0.1%
Missing	1170692
Missing (%)	12.7%
Memory size	140.8 MiB

OUO	1257167
EIE	298029
LFF	278498
UGK	202817
WXA	182412
Other values (142)	5834972

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WXA
2nd row	RRS
3rd row	OUO
4th row	LPF
5th row	LFF

Common Values

Value	Count	Frequency (%)
OUO	1257167	13.6%
EIE	298029	3.2%
LFF	278498	3.0%
UGK	202817	2.2%
WXA	182412	2.0%
FBI	176627	1.9%
NTH	175712	1.9%
GMW	169386	1.8%
FOH	168418	1.8%
LFN	166213	1.8%
Other values (137)	4978616	54.0%
(Missing)	1170692	12.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ouo	1257167	15.6%
eie	298029	3.7%
lff	278498	3.5%
ugk	202817	2.5%
wxa	182412	2.3%
fbi	176627	2.2%
nth	175712	2.2%
gmw	169386	2.1%
foh	168418	2.1%
lfn	166213	2.1%
Other values (137)	4978616	61.8%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_DESTINATION_COUNTRY_CODE
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	50
Distinct (%)	< 0.1%
Missing	1170692
Missing (%)	12.7%
Memory size	140.8 MiB

PL	2214715
DE	612387
UA	492939
US	405214
EE	278564
Other values (45)	4050076

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FR
2nd row	CA
3rd row	PL
4th row	DE
5th row	EE

Common Values

Value	Count	Frequency (%)
PL	2214715	24.0%
DE	612387	6.6%
UA	492939	5.3%
US	405214	4.4%
EE	278564	3.0%
FR	240963	2.6%
NL	212840	2.3%
RU	202213	2.2%
LT	200527	2.2%
GB	179586	1.9%
Other values (40)	3013947	32.7%
(Missing)	1170692	12.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pl	2214715	27.5%
de	612387	7.6%
ua	492939	6.1%
us	405214	5.0%
ee	278564	3.5%
fr	240963	3.0%
nl	212840	2.6%
ru	202213	2.5%
lt	200527	2.5%
gb	179586	2.2%
Other values (40)	3013947	37.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

BOOKING_ARRIVAL_TIME_UTC
Categorical

HIGH CARDINALITY

Distinct	86418
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	140.8 MiB

2008-01-03 18:05:00	1648
2008-01-06 18:05:00	1625
2007-09-09 00:10:00	1610
2007-11-04 18:05:00	1608
2007-09-01 00:10:00	1586
Other values (86413)	9216510

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1313 ?
Unique (%)	< 0.1%

Sample

1st row	2007-05-16 19:55:00
2nd row	2007-09-16 10:40:00
3rd row	2007-03-21 01:50:00
4th row	2007-04-15 14:15:00
5th row	2007-01-17 17:05:00

Common Values

Value	Count	Frequency (%)
2008-01-03 18:05:00	1648	< 0.1%
2008-01-06 18:05:00	1625	< 0.1%
2007-09-09 00:10:00	1610	< 0.1%
2007-11-04 18:05:00	1608	< 0.1%
2007-09-01 00:10:00	1586	< 0.1%
2008-01-02 18:05:00	1573	< 0.1%
2008-01-01 18:05:00	1543	< 0.1%
2007-12-30 18:05:00	1517	< 0.1%
2007-09-16 00:10:00	1495	< 0.1%
2008-01-04 18:05:00	1477	< 0.1%
Other values (86408)	9208905	99.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:10:00	198492	1.1%
19:40:00	180242	1.0%
17:05:00	142496	0.8%
14:15:00	132105	0.7%
17:00:00	125269	0.7%
16:55:00	122411	0.7%
21:45:00	121380	0.7%
16:50:00	120447	0.7%
20:45:00	119926	0.7%
20:55:00	118994	0.6%
Other values (1202)	17067412	92.5%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	TICKET_NUMBER	COUPON_NUMBER	ORIGIN_AIRPORT_CODE	DESTINATION_AIRPORT_CODE	FLIGHT_DATE_LOCAL	TIME_DEPARTURE_LOCAL_TIME	FLIGHT_DISTANCE	FLIGHT_RANGE	MARKETING_CARRIER	OPERATIONAL_CARRIER	BOOKED_CLASS	BOOKED_CABIN	AIRCRAFT_TYPE	FARE_BASIS	VAB	UPGRADED_FLAG	UPGRADE_TYPE	UPGRADE_SALES_DATE	BOOKING_ID	ORIGINAL_TICKET_NUMBER	FORM_OF_PAYMENT	CURRENCY	TOTAL_PRICE	TOTAL_PRICE_PLN	PAX_GENDER	PAX_TYPE	CORPORATE_CONTRACT_FLG	LOYAL_CUSTOMER	LOYAL_CUSTOMER_ID	LOYAL_CUSTOMER_DATE_OF_BIRTH	LOYAL_CUSTOMER_REGISTERED_DATE	SALES_DATE	SALES_MARKET	SALES_CHANNEL	TRIP_TYPE	BOOKING_WINDOW_D	STAY_LENGTH_D	BOOKING_LONG_HOUL_FLAG	BOOKING_DOMESTIC_FLAG	FLIGHT_COUPONS	SEGMENTS	PAX_N	INTINERARY	BOOKING_ORIGIN_AIRPORT	BOOKING_ORIGIN_COUNTRY_CODE	BOOKING_DEPARTURE_TIME_UTC	BOOKING_DESTINATION_AIRPORT	BOOKING_DESTINATION_COUNTRY_CODE	BOOKING_ARRIVAL_TIME_UTC
0	8604424865748057	2	WXA	OUO	2007-05-16	19:40:00	1344	SHORT-HAUL	2434615205489683	2434615205489683	O	Economy	738	OZSTDJ0	STANDARD	N	NaN	NaN	9592374534247938	9379265972706784	CA	PLN	620.35	620.35	M	ADULT	N	N	NaN	NaN	NaN	2007-01-11	2460355646543430	LOT TRAVEL	ROUND TRIP	121.0	4.0	N	N	2	2	1	OUO-WXA-OUO	OUO	PL	2007-05-12 05:25:00	WXA	FR	2007-05-16 19:55:00
1	9018301813990125	1	OUO	RRS	2007-08-26	13:55:00	6942	LONG-HAUL	2434615205489683	2434615205489683	U	Economy	788	UKPRO10	BASIC	N	NaN	NaN	4812269783756930	9379265972706784	CA	EUR	514.97	2151.49	M	ADULT	N	N	NaN	NaN	NaN	2007-01-10	5703060120714659	AGENTS	ROUND TRIP	228.0	21.0	Y	N	8	2	4	OUO-RRS-OUO	OUO	PL	2007-08-26 11:55:00	RRS	CA	2007-09-16 10:40:00
2	2822510487722780	2	OUO	HIX	2007-03-20	16:40:00	7521	LONG-HAUL	2434615205489683	2434615205489683	U	Economy	788	ULPRO11	BASIC	N	NaN	NaN	6366425806050664	9379265972706784	CCVI4	USD	648.77	2270.18	F	ADULT	N	N	NaN	NaN	NaN	2007-01-10	6982998843464221	LOT.COM	ROUND TRIP	55.0	15.0	Y	N	2	2	1	HIX-OUO-HIX	HIX	US	2007-03-06 03:35:00	OUO	PL	2007-03-21 01:50:00
3	2549944156700091	1	DZN	OUO	2007-04-08	06:05:00	721	SHORT-HAUL	2434615205489683	2434615205489683	W	Economy	E75	WSTDK0	STANDARD	N	NaN	NaN	928788763983290	9379265972706784	CA	UAH	8445.00	1096.16	F	ADULT	N	N	NaN	NaN	NaN	2007-03-27	1319526191137192	AGENTS	ROUND TRIP	12.0	7.0	N	N	4	2	1	DZN-OUO-LPF-OUO-EVJ	DZN	UA	2007-04-08 03:05:00	LPF	DE	2007-04-15 14:15:00
4	1190217539484680	2	LFF	NTH	2007-01-17	18:05:00	522	SHORT-HAUL	2434615205489683	2434615205489683	W	Economy	CRN	WCSERT/UD10	OTHER	N	NaN	NaN	7808680843506160	9379265972706784	CA	EUR	180.03	752.15	M	ADULT	N	N	NaN	NaN	NaN	2007-01-10	4311501618921268	AGENTS	ROUND TRIP	6.0	1.0	N	N	2	2	1	NTH-LFF-NTH	NTH	LT	2007-01-16 17:35:00	LFF	EE	2007-01-17 17:05:00
5	224145214135710	2	OUO	SIB	2007-05-13	17:00:00	1038	SHORT-HAUL	2434615205489683	2434615205489683	V	Economy	73C	VSAVM0	SAVER	N	NaN	NaN	5700517801904084	9379265972706784	CA	CHF	309.50	1102.53	M	ADULT	N	N	NaN	NaN	NaN	2007-01-11	7445666648510309	AGENTS	ROUND TRIP	119.0	3.0	N	N	8	2	4	SIB-OUO-SIB	SIB	CH	2007-05-10 08:25:00	OUO	PL	2007-05-13 17:05:00
6	2672232450915743	4	OUO	UIT	2007-04-08	16:55:00	818	SHORT-HAUL	2434615205489683	2434615205489683	Z	Business	CRN	ZSPC	OTHER	N	NaN	NaN	6906782215330386	9379265972706784	CCAX3	EUR	300.33	1254.75	M	ADULT	N	N	NaN	NaN	NaN	2007-01-10	4656329746243382	AGENTS	ROUND TRIP	81.0	7.0	N	N	12	2	3	UIT-OUO-NWZ-OUO-UIT	UIT	SE	2007-04-01 05:55:00	NWZ	IT	2007-04-08 16:45:00
7	8790040538825476	1	OUO	VMX	2007-04-27	19:45:00	537	SHORT-HAUL	2434615205489683	2434615205489683	O	Economy	DH4	OZSAVJ0	SAVER	N	NaN	NaN	3533750986330132	9379265972706784	CCCA5	PLN	350.00	350.00	F	ADULT	N	Y	5.503844e+15	1961-03-26	1996-06-13	2007-01-11	2460355646543430	LOT.COM	ROUND TRIP	106.0	10.0	N	N	6	2	3	OUO-VMX-OUO	OUO	PL	2007-04-27 17:45:00	VMX	HU	2007-05-07 06:20:00
8	1793755400865569	3	OUO	HIX	2007-03-29	16:45:00	7521	LONG-HAUL	2434615205489683	2434615205489683	H	Economy	788	HLXINK/UD06	STANDARD	N	NaN	NaN	9001348633253531	9379265972706784	CCVI4	USD	1300.81	4457.10	M	ADULT	N	N	NaN	NaN	NaN	2007-03-23	6982998843464221	AGENTS	ROUND TRIP	3.0	4.0	Y	N	3	2	1	HIX-EIE-OUO-HIX	HIX	US	2007-03-26 02:30:00	EIE	PL	2007-03-30 00:35:00
9	1866024256217792	2	OUO	AXT	2007-03-28	10:35:00	290	DOMESTIC	2434615205489683	2434615205489683	T	Economy	DH4	TLOSEA	OTHER	N	NaN	NaN	9638566344328939	9379265972706784	CA	EUR	183.29	775.23	M	ADULT	N	N	NaN	NaN	NaN	2007-03-26	4391133056062766	AGENTS	MULTICITY	2.0	0.0	N	N	2	1	1	BUG-OUO-AXT	BUG	DE	2007-03-28 05:00:00	NaN	NaN	2007-03-28 09:30:00

Last rows

	TICKET_NUMBER	COUPON_NUMBER	ORIGIN_AIRPORT_CODE	DESTINATION_AIRPORT_CODE	FLIGHT_DATE_LOCAL	TIME_DEPARTURE_LOCAL_TIME	FLIGHT_DISTANCE	FLIGHT_RANGE	MARKETING_CARRIER	OPERATIONAL_CARRIER	BOOKED_CLASS	BOOKED_CABIN	AIRCRAFT_TYPE	FARE_BASIS	VAB	UPGRADED_FLAG	UPGRADE_TYPE	UPGRADE_SALES_DATE	BOOKING_ID	ORIGINAL_TICKET_NUMBER	FORM_OF_PAYMENT	CURRENCY	TOTAL_PRICE	TOTAL_PRICE_PLN	PAX_GENDER	PAX_TYPE	CORPORATE_CONTRACT_FLG	LOYAL_CUSTOMER	LOYAL_CUSTOMER_ID	LOYAL_CUSTOMER_DATE_OF_BIRTH	LOYAL_CUSTOMER_REGISTERED_DATE	SALES_DATE	SALES_MARKET	SALES_CHANNEL	TRIP_TYPE	BOOKING_WINDOW_D	STAY_LENGTH_D	BOOKING_LONG_HOUL_FLAG	BOOKING_DOMESTIC_FLAG	FLIGHT_COUPONS	SEGMENTS	PAX_N	INTINERARY	BOOKING_ORIGIN_AIRPORT	BOOKING_ORIGIN_COUNTRY_CODE	BOOKING_DEPARTURE_TIME_UTC	BOOKING_DESTINATION_AIRPORT	BOOKING_DESTINATION_COUNTRY_CODE	BOOKING_ARRIVAL_TIME_UTC
9224577	4956915679887069	1	NTH	OUO	2007-03-23	10:05:00	402	SHORT-HAUL	2434615205489683	2434615205489683	T	Economy	DH4	T1STD7	STANDARD	N	NaN	NaN	2306558444176302	9379265972706784	CCCA5	PLN	768.40	768.40	M	ADULT	N	N	NaN	NaN	NaN	2007-03-16	2460355646543430	AGENTS	ONE WAY	7.0	-9999.0	N	N	1	1	1	NTH-OUO	NTH	LT	2007-03-23 08:05:00	OUO	PL	2007-03-23 09:15:00
9224578	3710559973746607	2	FZX	LFF	2007-02-05	00:10:00	313	SHORT-HAUL	2434615205489683	4676356571680678	L	Economy	AT7	LCSERT	OTHER	N	NaN	NaN	8590947427269758	9379265972706784	CA	RUB	16342.00	975.62	M	ADULT	N	N	NaN	NaN	NaN	2007-01-29	5218436844853814	AGENTS	ROUND TRIP	4.0	2.0	N	N	2	2	1	LFF-FZX-LFF	LFF	EE	2007-02-02 19:35:00	FZX	RU	2007-02-04 22:10:00
9224579	1896674873991522	1	CYE	OUO	2007-07-27	22:00:00	6863	LONG-HAUL	2434615205489683	2434615205489683	V	Economy	789	VHWTAN	FLEX	N	NaN	NaN	6482198566933746	9379265972706784	CCCA5	USD	1296.42	4619.66	F	ADULT	N	N	NaN	NaN	NaN	2007-05-08	6982998843464221	LOT.COM	ROUND TRIP	81.0	23.0	Y	N	8	2	4	CYE-OUO-CYE	CYE	US	2007-07-28 02:00:00	OUO	PL	2007-08-20 00:05:00
9224580	5788837430384166	1	OUO	UGK	2007-08-15	16:45:00	1102	SHORT-HAUL	2434615205489683	2434615205489683	W	Economy	73H	WSTDI3	STANDARD	N	NaN	NaN	3392322298507818	9379265972706784	DOTPA	PLN	759.47	759.47	F	ADULT	N	N	NaN	NaN	NaN	2007-05-10	2460355646543430	LOT.COM	ROUND TRIP	97.0	3.0	N	N	6	2	3	OUO-UGK-OUO	OUO	PL	2007-08-15 14:45:00	UGK	NL	2007-08-18 19:40:00
9224581	3878978339327591	3	EDN	OUO	2007-09-07	14:45:00	819	SHORT-HAUL	2434615205489683	2434615205489683	W	Economy	DH4	WHWTAN/IN90	OTHER	N	NaN	NaN	1066950308331839	9379265972706784	CCVI4	USD	140.81	501.76	M	INFANT	N	N	NaN	NaN	NaN	2007-05-08	6982998843464221	LOT.COM	MULTICITY	76.0	47.0	Y	N	12	2	3	HIX-OUO-EDN-OUO-HIX	OUO	PL	2007-07-23 09:20:00	NaN	NaN	2007-09-08 00:35:00
9224582	1096632497884510	1	LPF	OUO	2007-02-05	19:30:00	523	SHORT-HAUL	2434615205489683	2434615205489683	V	Economy	DH4	V1STD0	STANDARD	N	NaN	NaN	6667025084007550	9379265972706784	CA	UAH	6803.00	813.64	M	ADULT	N	N	NaN	NaN	NaN	2007-02-05	1319526191137192	AGENTS	ONE WAY	0.0	-9999.0	N	N	2	1	1	LPF-OUO-DZN	LPF	DE	2007-02-05 18:30:00	DZN	UA	2007-02-05 23:10:00
9224583	3483070439818554	2	KHY	OUO	2007-08-04	17:55:00	1070	SHORT-HAUL	2434615205489683	2434615205489683	U	Economy	E75	USAVJ21	SAVER	N	NaN	NaN	8443510784484681	9379265972706784	DOTPA	PLN	675.51	675.51	M	ADULT	N	N	NaN	NaN	NaN	2007-04-02	2460355646543430	LOT.COM	ROUND TRIP	116.0	8.0	N	N	6	2	3	OUO-KHY-OUO	OUO	PL	2007-07-27 08:55:00	KHY	BG	2007-08-04 16:55:00
9224584	9976288626337719	1	BUG	OUO	2007-06-02	07:00:00	753	SHORT-HAUL	2434615205489683	2434615205489683	K	Economy	DH4	K1FLX0	FLEX	N	NaN	NaN	6121170802422076	9379265972706784	CA	CHF	398.00	1408.80	M	ADULT	N	N	NaN	NaN	NaN	2007-04-27	7445666648510309	AGENTS	ONE WAY	36.0	-9999.0	N	N	2	1	1	BUG-OUO-KNH	BUG	DE	2007-06-02 05:00:00	KNH	RU	2007-06-02 10:50:00
9224585	4552896002136837	1	HLJ	OUO	2007-09-16	18:00:00	940	SHORT-HAUL	2434615205489683	2434615205489683	S	Economy	E75	SSAVJ14	SAVER	N	NaN	NaN	4119997402118093	9379265972706784	CA	RUB	20715.00	1157.97	M	ADULT	N	N	NaN	NaN	NaN	2007-08-10	5218436844853814	AGENTS	ROUND TRIP	37.0	3.0	N	N	6	2	3	HLJ-OUO-HLJ	HLJ	RO	2007-09-16 15:00:00	OUO	PL	2007-09-19 22:25:00
9224586	8440648241069803	1	OUO	GPJ	2007-05-16	16:50:00	1138	SHORT-HAUL	2434615205489683	2434615205489683	K	Economy	E95	K1STD9	STANDARD	N	NaN	NaN	1653636004649110	9379265972706784	CCAX3	EUR	300.21	1284.03	M	ADULT	N	N	NaN	NaN	NaN	2007-05-07	4656329746243382	AGENTS	ONE WAY	9.0	-9999.0	N	N	1	1	1	OUO-GPJ	OUO	PL	2007-05-16 14:50:00	GPJ	IT	2007-05-16 17:00:00

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters